forum

home / developersection / forums / call stored procedures with entity framework 6 data first approach in asp.net mvc 4

Ask Question

Call stored procedures with Entity Framework 6 data first approach in Asp.Net MVC 4

Manish Kumar 1327 24-May-2018

I am using mvc framerwork 4.5 with entityframework 6.0 .Can someone tell me how to call store procedure with parameter 


asp.net asp.net  asp.net mvc 
Updated on 24-May-2018
Manish Kumar

Other

Follow
Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

24-May-2018

I telling you how to get record using store procedure 

 using (var db = new MindStickDBEntities())

                    {

                        var cmd = db.Database.Connection.CreateCommand();

                        cmd.CommandText = "[dbo].[Sp_Getrecord]";

                        cmd.CommandType = CommandType.StoredProcedure;

                        cmd.Parameters.Add(new SqlParameter("@pageNo", pageNo));

                        cmd.Parameters.Add(new SqlParameter("@pageSize", pageSize));



                        try

                        {

                            db.Database.Connection.Open();

                            using (var result = cmd.ExecuteReader())

                            {

                                var recordlist= ((IObjectContextAdapter)db).ObjectContext.Translate<PostModel>(result).ToList();

                                result.NextResult(); 





                            }



                        }

hope it helps you..

advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy